A visual basic spreadsheet macro for recession curve analysis.
نویسندگان
چکیده
A Visual Basic program for an Excel spreadsheet was written to construct a master recession curve (MRC), using the adapted matching strip method, for recession analysis of ground water level time series. The program uses five different linear/nonlinear regression models to adjust individual recession segments to their proper positions in the MRC. The program can also be used to analyze the recession segments of other time series, such as daily stream discharge or stage. Some examples of field data from Croatia are used to illustrate the usefulness of its application.
منابع مشابه
Visual Basic Applications and Spreadsheet for Teaching Estimation of Nonparametric Density and Regression Functions
The aim of this paper is to show how teachers can use Visual Basic language on the spreadsheet for student sin order to gain the skills need in using nonparametric techniques for density and regression function estimations. The author has built a useful didactic tool on Excel Visual Basic for teaching and practice of nonparametric kernel methods, being intended for students with some preliminar...
متن کاملPKSolver: An add-in program for pharmacokinetic and pharmacodynamic data analysis in Microsoft Excel
This study presents PKSolver, a freely available menu-driven add-in program for Microsoft Excel written in Visual Basic for Applications (VBA), for solving basic problems in pharmacokinetic (PK) and pharmacodynamic (PD) data analysis. The program provides a range of modules for PK and PD analysis including noncompartmental analysis (NCA), compartmental analysis (CA), and pharmacodynamic modelin...
متن کاملAnalysis of Khorramabad Motahari Karstic Springhead (Sarab) Recession Curve Based on Recession Coefficient during Hydro-Climatic Fluctuations
The hydrographic specifications of the karstic spring and the recession coefficient can reflect the hydro-climatic fluctuations and physical and geological characteristics of the aquifer system recharging the spring. In this study, in order to identify the hydrological geological behavior of Khorramabad Motahhari karstic Springhead (Sarab) during hydro-climatic fluctuations, quantitative analys...
متن کاملSpreadsheet Education Material Using Remote Sensing Image and Map Image
Remote sensing satellite image, topographical map and vegetation map images are helpful education material for environmental studies of college or high school students. Students can research actual information of environment by analysis of these images. However, it was difficult to analyze the images by a conventional programming method. To solve this problem, we have developed new education ma...
متن کاملVeriClick: an efficient tool for table format verification
The essential layout attributes of a visual table can be defined by the location of four critical grid cells. Although these critical cells can often be located by automated analysis, some means of human interaction is necessary for correcting residual errors. VeriClick is a macro-enabled spreadsheet interface that provides ground-truthing, confirmation, correction, and verification functions f...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید
ثبت ناماگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید
ورودعنوان ژورنال:
- Ground water
دوره 44 5 شماره
صفحات -
تاریخ انتشار 2006